{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='福田')|(price['brand']=='宝沃')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['宝沃汽车>>', '宝沃新能源>>', '福田商用车>>', '福田汽车>>', '福田商用车新能源>>'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LVA')|(all1['3']=='LVC')|(all1['3']=='LXV')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BW6470B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BW6471B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BW6474B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1797</td>\n",
       "      <td>140</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BW6474B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1797</td>\n",
       "      <td>140</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BW6473B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BW6473B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BW6470B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BW6471B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BW6471B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BW6471B1X5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1776</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BW6471B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BW6471B1X5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1776</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BW6471B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BW6470B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BW6470B1X5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1776</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BW6470B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BW6470B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BW6460A4Y5J</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1670</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BW6460A4X5J</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1550</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BW6460A4X5F</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1545</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LXVD3GEC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BW6460A4X5E</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1545</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LXVD3GEC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BW6460A4X5G</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1580</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1797</td>\n",
       "      <td>140</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BW6460A4X5F</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1545</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LXVD3GEC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BW6460A4X5E</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1545</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LXVD3GEC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BW6460A4X5F</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1545</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BW6460A4X5E</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1545</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BW6460A4X5J</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1550</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BW6460A4Y5J</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1670</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BJ6608BDDVA-P5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2285</td>\n",
       "      <td>3750</td>\n",
       "      <td>5990</td>\n",
       "      <td>2000</td>\n",
       "      <td>2445</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3750</td>\n",
       "      <td>5990x2000x2445</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BJ6608BDDVA-K5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2285</td>\n",
       "      <td>3750</td>\n",
       "      <td>5990</td>\n",
       "      <td>2000</td>\n",
       "      <td>2445</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3750</td>\n",
       "      <td>5990x2000x2445</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>BJ6393MD31A-CB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>995</td>\n",
       "      <td>50</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>BJ6393MD31A-CB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>995</td>\n",
       "      <td>50</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>BJ6393MD31A-CA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1055</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>995</td>\n",
       "      <td>50</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>BJ6393MD31A-CA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1055</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>995</td>\n",
       "      <td>50</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>BJ6393MD31A-DB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1015</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>998</td>\n",
       "      <td>45</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>BJ6393MD31A-DB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1015</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>998</td>\n",
       "      <td>45</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>BJ6393MD31A-DA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1035</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>998</td>\n",
       "      <td>45</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>BJ6393MD31A-DA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1035</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>998</td>\n",
       "      <td>45</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>BJ6393MD32A-AB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>1206</td>\n",
       "      <td>63</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>BJ6393MD32A-AB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>1206</td>\n",
       "      <td>63</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>BJ6393MD32A-AA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1055</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>1206</td>\n",
       "      <td>63</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>BJ6393MD32A-AA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1055</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>1206</td>\n",
       "      <td>63</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>BJ6526BDDBA-F1</td>\n",
       "      <td>福田</td>\n",
       "      <td>2085</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2500</td>\n",
       "      <td>96</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>BJ6526BCDBA-F1</td>\n",
       "      <td>福田</td>\n",
       "      <td>2085</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2500</td>\n",
       "      <td>96</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>BJ6526BDDBA-F1</td>\n",
       "      <td>福田</td>\n",
       "      <td>2085</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2500</td>\n",
       "      <td>96</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>BJ6526BCDBA-F1</td>\n",
       "      <td>福田</td>\n",
       "      <td>2085</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2500</td>\n",
       "      <td>96</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>BJ6526BDDVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2010</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCB2NVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>BJ6526BDDXA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2010</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2FWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>BJ6526BDDBA-F1</td>\n",
       "      <td>福田</td>\n",
       "      <td>2085</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2500</td>\n",
       "      <td>96</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>BJ6526BCDBA-F1</td>\n",
       "      <td>福田</td>\n",
       "      <td>2085</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2500</td>\n",
       "      <td>96</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>BJ6539BDPDA-DD</td>\n",
       "      <td>福田</td>\n",
       "      <td>2105</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>2771</td>\n",
       "      <td>70</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>BJ6539BDPVA-AC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>BJ6539BDPDA-CD</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>2771</td>\n",
       "      <td>70</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>BJ6539BDPVA-CC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1885</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>BJ6539BDPVA-C5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1885</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>BJ6539BDPVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>BJ6539BDPVA-AC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>BJ6539BDPDA-CD</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>2771</td>\n",
       "      <td>70</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>BJ6539BDPVA-CC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1885</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>BJ6539BDPDA-DD</td>\n",
       "      <td>福田</td>\n",
       "      <td>2105</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>2771</td>\n",
       "      <td>70</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>256 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0       BW6470B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "1       BW6471B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "2       BW6474B1X5A      宝沃        1668      2760       4715      1911   \n",
       "3       BW6474B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "4       BW6473B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "5       BW6473B1X5A      宝沃        1668      2760       4715      1911   \n",
       "6       BW6470B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "7       BW6471B1X5A      宝沃        1668      2760       4715      1911   \n",
       "8       BW6471B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "9       BW6471B1X5B      宝沃        1776      2760       4715      1911   \n",
       "10      BW6471B1X5A      宝沃        1668      2760       4715      1911   \n",
       "11      BW6471B1X5B      宝沃        1776      2760       4715      1911   \n",
       "12      BW6471B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "13      BW6470B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "14      BW6470B1X5B      宝沃        1776      2760       4715      1911   \n",
       "15      BW6470B1X5A      宝沃        1668      2760       4715      1911   \n",
       "16      BW6470B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "17      BW6460A4Y5J      宝沃        1670      2685       4601      1877   \n",
       "18      BW6460A4X5J      宝沃        1550      2685       4601      1877   \n",
       "19      BW6460A4X5F      宝沃        1545      2685       4601      1877   \n",
       "20      BW6460A4X5E      宝沃        1545      2685       4601      1877   \n",
       "21      BW6460A4X5G      宝沃        1580      2685       4601      1877   \n",
       "22      BW6460A4X5F      宝沃        1545      2685       4601      1877   \n",
       "23      BW6460A4X5E      宝沃        1545      2685       4601      1877   \n",
       "24      BW6460A4X5F      宝沃        1545      2685       4601      1877   \n",
       "25      BW6460A4X5E      宝沃        1545      2685       4601      1877   \n",
       "26      BW6460A4X5J      宝沃        1550      2685       4601      1877   \n",
       "27      BW6460A4Y5J      宝沃        1670      2685       4601      1877   \n",
       "28   BJ6608BDDVA-P5      福田        2285      3750       5990      2000   \n",
       "29   BJ6608BDDVA-K5      福田        2285      3750       5990      2000   \n",
       "..              ...     ...         ...       ...        ...       ...   \n",
       "226  BJ6393MD31A-CB      福田        1025      2500       3915      1640   \n",
       "227  BJ6393MD31A-CB      福田        1025      2500       3915      1640   \n",
       "228  BJ6393MD31A-CA      福田        1055      2500       3915      1640   \n",
       "229  BJ6393MD31A-CA      福田        1055      2500       3915      1640   \n",
       "230  BJ6393MD31A-DB      福田        1015      2500       3915      1640   \n",
       "231  BJ6393MD31A-DB      福田        1015      2500       3915      1640   \n",
       "232  BJ6393MD31A-DA      福田        1035      2500       3915      1640   \n",
       "233  BJ6393MD31A-DA      福田        1035      2500       3915      1640   \n",
       "234  BJ6393MD32A-AB      福田        1025      2500       3915      1640   \n",
       "235  BJ6393MD32A-AB      福田        1025      2500       3915      1640   \n",
       "236  BJ6393MD32A-AA      福田        1055      2500       3915      1640   \n",
       "237  BJ6393MD32A-AA      福田        1055      2500       3915      1640   \n",
       "238  BJ6526BDDBA-F1      福田        2085      3430       5245      1825   \n",
       "239  BJ6526BCDBA-F1      福田        2085      3430       5245      1825   \n",
       "240  BJ6526BDDBA-F1      福田        2085      3430       5245      1825   \n",
       "241  BJ6526BCDBA-F1      福田        2085      3430       5245      1825   \n",
       "242  BJ6526BDDVA-A5      福田        2010      3430       5245      1825   \n",
       "243  BJ6526BDDXA-A5      福田        2010      3430       5245      1825   \n",
       "244  BJ6526BDDBA-F1      福田        2085      3430       5245      1825   \n",
       "245  BJ6526BCDBA-F1      福田        2085      3430       5245      1825   \n",
       "246  BJ6539BDPDA-DD      福田        2105      3050       5320      1695   \n",
       "247  BJ6539BDPVA-AC      福田        1990      3050       5320      1695   \n",
       "248  BJ6539BDPDA-CD      福田        1990      3050       5320      1695   \n",
       "249  BJ6539BDPVA-CC      福田        1885      3050       5320      1695   \n",
       "250  BJ6539BDPVA-C5      福田        1885      3050       5320      1695   \n",
       "251  BJ6539BDPVA-A5      福田        1990      3050       5320      1695   \n",
       "252  BJ6539BDPVA-AC      福田        1990      3050       5320      1695   \n",
       "253  BJ6539BDPDA-CD      福田        1990      3050       5320      1695   \n",
       "254  BJ6539BDPVA-CC      福田        1885      3050       5320      1695   \n",
       "255  BJ6539BDPDA-DD      福田        2105      3050       5320      1695   \n",
       "\n",
       "    car_height Displacement power                vin   car_factory    3  \\\n",
       "0         1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "1         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "2         1690         1797   140  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "3         1690         1797   140  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "4         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "5         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "6         1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "7         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "8         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "9         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "10        1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "11        1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "12        1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "13        1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "14        1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "15        1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "16        1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "17        1656         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "18        1656         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "19        1656         1395   110  LXVD3GEC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "20        1656         1395   110  LXVD3GEC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "21        1656         1797   140  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "22        1656         1395   110  LXVD3GEC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "23        1656         1395   110  LXVD3GEC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "24        1656         1395   110  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "25        1656         1395   110  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "26        1656         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "27        1656         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "28        2445         1981   148  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "29        2445         1981   148  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "..         ...          ...   ...                ...           ...  ...   \n",
       "226       1845          995    50  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "227       1845          995    50  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "228       1845          995    50  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "229       1845          995    50  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "230       1845          998    45  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "231       1845          998    45  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "232       1845          998    45  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "233       1845          998    45  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "234       1845         1206    63  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "235       1845         1206    63  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "236       1845         1206    63  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "237       1845         1206    63  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "238       1950         2500    96  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "239       1950         2500    96  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "240       1950         2500    96  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "241       1950         2500    96  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "242       1950         1997    90  LVCB2NVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "243       1950         2378   100  LVCP2FWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "244       1950         2500    96  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "245       1950         2500    96  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "246       2240         2771    70  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "247       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "248       2240         2771    70  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "249       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "250       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "251       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "252       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "253       2240         2771    70  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "254       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "255       2240         2771    70  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "\n",
       "    轴距[mm]       长×宽×高[mm] brand_y  style  factory  \n",
       "0     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "1     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "2     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "3     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "4     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "5     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "6     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "7     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "8     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "9     2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "10    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "11    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "12    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "13    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "14    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "15    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "16    2760  4715x1911x1690      宝沃  宝沃BX7       16  \n",
       "17    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "18    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "19    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "20    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "21    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "22    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "23    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "24    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "25    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "26    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "27    2685  4601x1877x1656      宝沃  宝沃BX6        2  \n",
       "28    3750  5990x2000x2445      福田    图雅诺        2  \n",
       "29    3750  5990x2000x2445      福田    图雅诺        2  \n",
       "..     ...             ...     ...    ...      ...  \n",
       "226   2500  3915x1640x1845      福田   伽途V3       10  \n",
       "227   2500  3915x1640x1845      福田   风景V3       16  \n",
       "228   2500  3915x1640x1845      福田   伽途V3       10  \n",
       "229   2500  3915x1640x1845      福田   风景V3       16  \n",
       "230   2500  3915x1640x1845      福田   伽途V3       10  \n",
       "231   2500  3915x1640x1845      福田   风景V3       16  \n",
       "232   2500  3915x1640x1845      福田   伽途V3       10  \n",
       "233   2500  3915x1640x1845      福田   风景V3       16  \n",
       "234   2500  3915x1640x1845      福田   伽途V3       10  \n",
       "235   2500  3915x1640x1845      福田   风景V3       16  \n",
       "236   2500  3915x1640x1845      福田   伽途V3       10  \n",
       "237   2500  3915x1640x1845      福田   风景V3       16  \n",
       "238   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "239   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "240   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "241   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "242   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "243   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "244   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "245   3430  5245x1825x1950      福田   蒙派克E        2  \n",
       "246   3050  5320x1695x2240      福田   风景G7        5  \n",
       "247   3050  5320x1695x2240      福田   风景G7        5  \n",
       "248   3050  5320x1695x2240      福田   风景G7        5  \n",
       "249   3050  5320x1695x2240      福田   风景G7        5  \n",
       "250   3050  5320x1695x2240      福田   风景G7        5  \n",
       "251   3050  5320x1695x2240      福田   风景G7        5  \n",
       "252   3050  5320x1695x2240      福田   风景G7        5  \n",
       "253   3050  5320x1695x2240      福田   风景G7        5  \n",
       "254   3050  5320x1695x2240      福田   风景G7        5  \n",
       "255   3050  5320x1695x2240      福田   风景G7        5  \n",
       "\n",
       "[256 rows x 17 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "#result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])\n",
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>LVCP2GVC×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>LVCP2GVC×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V5EV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>LVCB2NBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>LVCB2NBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>LVCP2FWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>LVCP2CWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>LVCB2NVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>LVCP2CBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>LVCB2PVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>LVCP2GBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途V3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>LVCB2NVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>LVCP2FWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   vin   car_factory brand   style\n",
       "0    LVCP2FVA×××××××××  北汽福田汽车股份有限公司    福田     图雅诺\n",
       "4    LVCP2FBA×××××××××  北汽福田汽车股份有限公司    福田     图雅诺\n",
       "40   LVCP2GVA×××××××××  北汽福田汽车股份有限公司    福田    伽途im\n",
       "50   LVCP2GVA×××××××××  北汽福田汽车股份有限公司    福田    伽途GT\n",
       "52   LVCP2GVC×××××××××  北汽福田汽车股份有限公司    福田    伽途GT\n",
       "53   LVCP2GVC×××××××××  北汽福田汽车股份有限公司    福田    伽途im\n",
       "84   LVCP2DVA×××××××××  北汽福田汽车股份有限公司    福田    风景V5\n",
       "86   LVCP2DVA×××××××××  北汽福田汽车股份有限公司    福田  风景V5EV\n",
       "197  LVCB2NBA×××××××××  北汽福田汽车股份有限公司    福田     图雅诺\n",
       "238  LVCB2NBA×××××××××  北汽福田汽车股份有限公司    福田    风景G9\n",
       "242  LVCP2FWA×××××××××  北汽福田汽车股份有限公司    福田    风景G9\n",
       "254  LVCP2CWA×××××××××  北汽福田汽车股份有限公司    福田    风景G9\n",
       "262  LVCP2FVA×××××××××  北汽福田汽车股份有限公司    福田    风景G9\n",
       "266  LVCP2FBA×××××××××  北汽福田汽车股份有限公司    福田    风景G9\n",
       "270  LVCB2NVA×××××××××  北汽福田汽车股份有限公司    福田    风景G9\n",
       "302  LVCP2DVA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "304  LVCP2GVA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "306  LVCP2CBA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "308  LVCP2GWA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "316  LVCB2PVA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "320  LVCP2GBA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "352  LVCP2DVA×××××××××  北汽福田汽车股份有限公司    福田    伽途V3\n",
       "353  LVCP2DVA×××××××××  北汽福田汽车股份有限公司    福田    风景V3\n",
       "421  LVCP2FBA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "425  LVCB2NVA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "426  LVCP2FWA×××××××××  北汽福田汽车股份有限公司    福田    蒙派克E\n",
       "429  LVCP2FBA×××××××××  北汽福田汽车股份有限公司    福田    风景G7\n",
       "431  LVCP2FVA×××××××××  北汽福田汽车股份有限公司    福田    风景G7"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
